﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace Supermarkets
{
    class Program
    {
        static void Main(string[] args)
        {
            ExcelReader reader = new ExcelReader();
            string dataSource = "Sample-Sales-Report.xlsx";
            DataTable dt = reader.ReadExcel(dataSource);

            Dictionary<int, string> products = new MySQLManager().LoadProductData();
            Writer2 PDFWriter = new Writer2(products);
            PDFWriter.Open();
            PDFWriter.Write(dt);
            PDFWriter.Close();
        }
    }
}
